Write Cell
AutomatR.Excel.Activities.WriteCell
The "Write Cell" activity in AutomatR is part of the Excel activities package, facilitating the automation of spreadsheet data manipulation within Microsoft Excel. This activity writes a specified value or formula into a designated cell, streamlining the process of updating Excel data dynamically.
NOTE: This activity can only be used in Excel Root activity.
Properties
| Name | Description |
|---|---|
| Input | |
| Cell Number | Enter the cell number where you want to start writing the data. String variables containing the cell number, e.g., "A1" or "B2". |
| Value | Enter the value you wish to enter as text, a cell formula, or a stored variable. String variables containing the data to be written into the cell. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Write Cell" activity onto the workflow.
- Configure the properties by specifying the cell number and the value to be written into the Excel spreadsheet.
- Optionally, configure the delay.
- Execute the workflow to write the specified data into the designated cell.
Important:
- Ensure that the Excel workbook is open and accessible.
- Provide a valid cell number (e.g., "A1") and the value to be written.